---
title: DB-CLL-007 — Retrieve case status history, newest first
summary: Retrieve case status history, newest first
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-007 — Retrieve case status history, newest first

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-007 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsCaseStatusHistoryCollection |
| Criteria property | MyRetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier used to filter status history |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | SELECT | LEGAL_CASE_SEQ_NUM, CASE_STATUS_CODE, CREATE_DATE |

## Sample SQL

```sql
Select
  CASE_STATUS_HISTORY.CASE_STATUS_HISTORY_SEQ_NUM as CaseStatusHistoryID,
  CASE_STATUS_HISTORY.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  CASE_STATUS_HISTORY.CASE_STATUS_CODE as CaseStatusCode,
  CASE_STATUS_HISTORY.CREATE_DATE as CreateDate
From
  CASE_STATUS_HISTORY
Where
  CASE_STATUS_HISTORY.LEGAL_CASE_SEQ_NUM = :LegalCaseID
Order by
  CASE_STATUS_HISTORY_SEQ_NUM desc
```

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb`